CSM - A Maintenance Tool for Data Warehouse Structures

CoSM (Comet Structure Manager) is a tool for the maintenance of data warehouse structures based on the temporal data warehouse model COMET. Current data warehouse systems do not care for changes in dimension data. CoSM allows keeping track of modifications made in the dimension-structure of multidimensional cubes stored in an OLAP (On-Line Analytical Processing) system. CoSM can download dimension data from an OLAP System, and upload dimension data into an OLAP system, compare dimension data of an OLAP system with stored versions and provides functions for insertion, deletion and change of dimensions, levels, dimension members, and their relationships.